package com.jspgou.cms.dao;

import java.util.Date;
import java.util.List;

import com.jspgou.cms.entity.OrderItem;
import com.jspgou.common.page.Pagination;

public interface OrderItemDao {
	
	public List<Object[]> profitTop(Long ctgid,Long typeid,Integer pageNo,Integer pageSize);
	
	public Integer totalCount(Long ctgid,Long typeid);
	
	public List<Object[]> getOrderItem();
	
	public OrderItem findById(Long id);
	
	public OrderItem findByMember(Long memberId,Long productId);
	
	public Object[] getPageByMember(Long webId,int status,Long memberId,int pageNo,int pageSize);

	public Pagination getPage(Long webId,Long productId,Long paymentId,Long shippingId,Long storeId,
			String code,Date startTime,Date endTime,Integer status,Integer paymentStatus,Integer shippingStatus,int pageNo,int pageSize);
	
	public List<OrderItem> getList(Long webId,Long productId,Long paymentId,Long shippingId,
			String code,Date startTime,Date endTime,Integer status);
	
	public List<OrderItem> getOrderItem(Long productId);
	
	public List<OrderItem> getOrderItemList(Long productId,Integer pageNo,Integer pageSize);
}

